//
//  DataBaseSingleTon.h
//  豆瓣2
//
//  Created by dllo on 15/11/6.
//  Copyright (c) 2015年 张鸿峰. All rights reserved.
//

#import <Foundation/Foundation.h>

#import "ActivityList.h"

#import "ActivityStore.h"

#import "User.h"

@interface DataBaseSingleTon : NSObject

+ (instancetype)shareDataBase;

//打开数据库
- (void)openDBAC;


// 创建活动表
- (void)createActivityTable;

//插入
- (void)insertActivity:(ActivityList *)act;

//删除数据
- (void)deleteActivity:(NSString *)sql;

//查询
- (NSMutableArray *)selectActivity:(NSString *)sql;

//删除整张活动表
- (void)dropTableAC;

// 创建活动收藏列表
- (void)createActivityStoreTable;

//插入活动收藏表
- (void)insertActivitysql:(NSString *)sql;

// 查询活动收藏列表
- (NSMutableArray *)selectActivityStoreSQL:(NSString *)sql;

//创建用户表
- (void)createUserTable;

//插入用户
- (void)insertUser:(User *)user;

//查询用户
- (NSMutableArray *)selectUserSQL:(NSString *)sql;

//删除用户表
- (void)dropTableUser:(NSString *)userName;

//删除活动收藏表
- (void)dropActivityStoreTable:(NSString *)userName;

@end
